UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nPSHSaQDgiWNCU/42p8rgAN8psOu72B5xGRLumunM0s='
WHERE
key_id = 'b4a8b4a8c543ef54f6da85cdafdd1561e62bab69bb5763cb1afb8da27ea6a095'
AND (
token = 'nPSHSaQDgiWNCU/42p8rgAN8psOu72B5xGRLumunM0s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)