UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hqZVlZA2ZJb8LL0RQqzzcU9h223Z1RNhMi7XuiyaiYg='
WHERE
key_id = '8ea681c70c45a1dc397f40a147e9b4004f0589cb1223840e9d93326c06f4a36a'
AND (
token = 'hqZVlZA2ZJb8LL0RQqzzcU9h223Z1RNhMi7XuiyaiYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)