UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DGoxzbLpyMWyfINkkbIxKas1dNd2Puay5R9bKOKP5Ok='
WHERE
key_id = '58a0a4195e7d4a02e7f2e627ed697b4d4f5894303d492317354674b3e2c7bdd8'
AND (
token = 'DGoxzbLpyMWyfINkkbIxKas1dNd2Puay5R9bKOKP5Ok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)