UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dIuXeXqUmqqTNe9I6dS9imnKIPJHKh/OJQC4+9F/zsg='
WHERE
key_id = 'db3cd0c2e82a79a86b2b1c2da59cea3c136578dca0371c3437d626deea934104'
AND (
token = 'dIuXeXqUmqqTNe9I6dS9imnKIPJHKh/OJQC4+9F/zsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)