UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xK7ObH9MkuefJY0HiTR/0iDYGL+oZ0CFpE5LVj70KMo='
WHERE
key_id = '6030db8cb17116fd47a008f24961142d212039ce41921c50f98e776f15870909'
AND (
token = 'xK7ObH9MkuefJY0HiTR/0iDYGL+oZ0CFpE5LVj70KMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)