UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0AOgwnb0gnRYWw5kRXy/64ImwqpYBYV5F07Q2HiQNSk='
WHERE
key_id = '4b7422053c0fe7e1c16585ee4f8567f613cd84b29f883c626c2c0c04efc986ae'
AND (
token = '0AOgwnb0gnRYWw5kRXy/64ImwqpYBYV5F07Q2HiQNSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)