UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zaazY40nAyU0m3KigRRg3F692/5V0qkA/MMzjLpnAo='
WHERE
key_id = '198da873a0aafc7541de2901c197866be35e64632e46e26025c245c7aae0d27a'
AND (
token = '0zaazY40nAyU0m3KigRRg3F692/5V0qkA/MMzjLpnAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)