UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GEnPrvAKij1/harsnkpf6F68mvBJ4D1zfFK32g+O7jY='
WHERE
key_id = '04b6968fd246c6f6119c9fbf00caebaf6429ae4544eb731b4599a984907685cf'
AND (
token = 'GEnPrvAKij1/harsnkpf6F68mvBJ4D1zfFK32g+O7jY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)