UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4m9QGyXdrSa1biKR5G6dQnER9MyKyVld2YGvzWNrDmI='
WHERE
key_id = '7ad50d5f135eb32b323b6c76a3fb79c8045459ff530365d2f7242bad7d1d2728'
AND (
token = '4m9QGyXdrSa1biKR5G6dQnER9MyKyVld2YGvzWNrDmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)