UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VFoDtI+7btboAJ/vXd98FkqFcRvMRcsYjslofVgT6Qg='
WHERE
key_id = 'a8896c35579ac290da064c7939780c3be244de576df8e27b9c451b7d531d78ad'
AND (
token = 'VFoDtI+7btboAJ/vXd98FkqFcRvMRcsYjslofVgT6Qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)