UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QScU8IDvllG6jcSxZ8G+vbib6uJU6ytPHYlTJNF4CjA='
WHERE
key_id = 'e8f538e36cc93367081c9499d5cd55c958fb9b7257d9c0f16ddbcc2bf4c00c6b'
AND (
token = 'QScU8IDvllG6jcSxZ8G+vbib6uJU6ytPHYlTJNF4CjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)