UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kp2b3HPopeAkuCIvOW2GZRtoG2oiZElDEy7NYLe6IAA='
WHERE
key_id = '47645a4f73eba22868d2fadda7220bf386c6f0f9b11c0f8ead4d17d280946635'
AND (
token = 'Kp2b3HPopeAkuCIvOW2GZRtoG2oiZElDEy7NYLe6IAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)