UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's0NsT7BNgnbL79EAyjQsF/udb64nWDXpkF3Y2AclVI0='
WHERE
key_id = 'f111d86edf54de1a652ca84d0f3dbb67df262b227f3c54bb6c6c37443e74211e'
AND (
token = 's0NsT7BNgnbL79EAyjQsF/udb64nWDXpkF3Y2AclVI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)