UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wsc8COXcMqE1qwF4JSzwny48Eoihd7ygnB+NmJTxLZw='
WHERE
key_id = 'a4c80db7da49364cbef303a939cb9c1653999ac7114090c28aecbf65c899bf4f'
AND (
token = 'wsc8COXcMqE1qwF4JSzwny48Eoihd7ygnB+NmJTxLZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)