UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'snQ+5+01MjsvHbdlSDqJ2Js0DuBf+koqZMPN202s/Rw='
WHERE
key_id = '14f1f22cd2a374904b14d409809e6c36e58ad17627ebe308af5a6b452db7c529'
AND (
token = 'snQ+5+01MjsvHbdlSDqJ2Js0DuBf+koqZMPN202s/Rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)