UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3igaa0kNEypRNnNhoO6+s1AopHdQA3f0b5588thoGgk='
WHERE
key_id = '38c03d645a3a9277fad24e30549f555f7169466092601c0142bd4a5aef9aed7f'
AND (
token = '3igaa0kNEypRNnNhoO6+s1AopHdQA3f0b5588thoGgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)