UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJI2Fbfi/uHi7uNFp/oCWt0myrfpgpf4KNfA0T2LWnA='
WHERE
key_id = '411e0069dfb8b74ff6568e729e2d12cfc069cecdc9721a7188bb98f62dd84c9a'
AND (
token = 'zJI2Fbfi/uHi7uNFp/oCWt0myrfpgpf4KNfA0T2LWnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)