UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NxW0BJvm8u9bnPBfFrVQykljBhUMMthqApnuorUh20U='
WHERE
key_id = '1d91adbe31505f52df6180f9323f64df5456a128debf2e5f8849459dcd500689'
AND (
token = 'NxW0BJvm8u9bnPBfFrVQykljBhUMMthqApnuorUh20U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)