UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RS6dG58uvQ5oGtkBudQU8T4Pc9n7p73YR6Nzi82mHmw='
WHERE
key_id = 'a9622d6fd87c555ac0daf94a04dc0133f011a3bc2db556a3f28a9c85bb972260'
AND (
token = 'RS6dG58uvQ5oGtkBudQU8T4Pc9n7p73YR6Nzi82mHmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)