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