UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zFHH4GmGstXjiaw0xxJPDbiLnsvLxsDS1e0eK0Tf2xA='
WHERE
key_id = 'f9305898bbea2f76f705ff38d6397b2c9a940ed1758cef7e76801b28ba0298ac'
AND (
token = 'zFHH4GmGstXjiaw0xxJPDbiLnsvLxsDS1e0eK0Tf2xA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)