UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fy5VqwO4kjH9AcnT77gAaiHsdRSoxKewYU8hpt0mD4='
WHERE
key_id = 'd92e5b4934a457066149d7b475a1023aa68a8cd32d3667d6d09872f0692425ed'
AND (
token = '0fy5VqwO4kjH9AcnT77gAaiHsdRSoxKewYU8hpt0mD4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)