UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQ6FLHE4faQT7oqOpUB0sDhnRBiKVbBOj+AotIgGzQE='
WHERE
key_id = '7974878188b6e1a723be9eca50008d25d1e4114a167f4f70e626fffcab07e630'
AND (
token = 'xQ6FLHE4faQT7oqOpUB0sDhnRBiKVbBOj+AotIgGzQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)