UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8MS0zYy5UL1m8Hma/06Bf2s93bnCqTYvDM6QlRR6/7Y='
WHERE
key_id = '392a0e1ed6f75a0c60cf4d2611e74abf2c8f6fd0547f6f5918a60c8f9020f334'
AND (
token = '8MS0zYy5UL1m8Hma/06Bf2s93bnCqTYvDM6QlRR6/7Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)