UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pPKrG3qSHJNjXT11jKe2Dl9X2YRHfZH3P9nc7hwT58g='
WHERE
key_id = 'cebc71b052cbfd68991d076f4021b54e4e8aaec39d5eedea7f5601345bfcc86f'
AND (
token = 'pPKrG3qSHJNjXT11jKe2Dl9X2YRHfZH3P9nc7hwT58g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)