UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G2+9jCK37unHvQicA8Qict7zZJaNttp81RecDDfhSoU='
WHERE
key_id = '1c066803fe0988d790434a9af30579b70de2d1b1cd4ddf1e5a3d65d80c97dae9'
AND (
token = 'G2+9jCK37unHvQicA8Qict7zZJaNttp81RecDDfhSoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)