UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gnBugTnC5xnd3MWDHevy/6hRjNJlGu1AbU8PbaFTFSo='
WHERE
key_id = '820b1adea0cf7918a56eee5b22c2a0896a606a8f0844fd8d184f457413871ea2'
AND (
token = 'gnBugTnC5xnd3MWDHevy/6hRjNJlGu1AbU8PbaFTFSo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)