UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z/b6hs0VFLWavdz1IpP/kKQcQ7KZfK9TMHcHX77Qq+I='
WHERE
key_id = 'dd2348ad2d739dee57b6c6e9913e3648b0b46fc699431a2e03ba4a60cbae987c'
AND (
token = 'z/b6hs0VFLWavdz1IpP/kKQcQ7KZfK9TMHcHX77Qq+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)