UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ZzvCq+To2xG+xVex/QVdHGae44ATSc0X1YwJnx+ECs='
WHERE
key_id = 'f3979bd41f988c2419a38a84eb9fe1f458c50986648bb41ebc8190be09e5c9f3'
AND (
token = '7ZzvCq+To2xG+xVex/QVdHGae44ATSc0X1YwJnx+ECs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)