UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd7lgr6bmkb1UycTEKy/8vj2lce7o0Vik5+Nk0ikLNY0='
WHERE
key_id = 'b59aface3b9a0c59163f9b324494f9f919b8f0b252331dc621c388529dcebb45'
AND (
token = 'd7lgr6bmkb1UycTEKy/8vj2lce7o0Vik5+Nk0ikLNY0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)