UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6WY/2veQW6GbeGlFTihS5YPjjBSEIKreqOuiAbW9LBE='
WHERE
key_id = 'e6a0a34485ce3879b956ab8a2cd3ef9bd11406874e204e8c8782e687227899a9'
AND (
token = '6WY/2veQW6GbeGlFTihS5YPjjBSEIKreqOuiAbW9LBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)